When you view the spend values for low-owned inventory products in the SAS^® High Performance Markdown Optimization Client, you might have incorrect values.

This error occurs because the GEO_PROD_OWNED_INV table is not correctly partitioned. The DI_DM.GEO_PROD_OWNED_INV table has the correct data, but the partition level GEO_PROD_OWNED_INV tables are incorrect.

To workaround this issue perform the following steps. All steps need to be performed in a SAS environment with the Merchandise Intelligence libraries allocated.

1. Run the macro %di_util_purge_deleted_records(DI_DM.GEO_PROD_OWNED_INV)
2. Run the %TKMI_JOB_RO partition_dm_hier_1 task
3. On a multi-machine environment run %TKMI_JOB_RO copyDataToCaptains_service
4. Run weekly batch optimization

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for SAS High-Performance Markdown Optimization 4.3_M2 is available at: